package com.dingding.service.user.core.sql;
/**
 * 
 * @ClassName: UserIntegralSQL 
 * @Description: 用户积分表操作SQL
 * @author CHEHUANBO 
 * @date 2016年4月4日 下午10:31:51
 * 
 */
public class UserIntegralSQL {
	
	/**
	 * 添加用户积分
	 * @author CHEHUANBO
	 */
	public static final String ADD_USER_INTEGRAL_BY_USERID = "UPDATE userintegral urg SET urg.userIntegral = urg.userIntegral + ? WHERE urg.loginId = ? ";
	
	/**
	 * 扣除用户积分
	 * @author CHEHUANBO
	 */
	public static final String DEDUCT_USER_INTEGRAL_BY_USERID = "UPDATE userintegral urg SET urg.userIntegral = urg.userIntegral - ? WHERE urg.loginId = ? ";

}
